package com.lanou.mapper;

import com.lanou.bean.T8Tcommodity.ColorSizePrice;
import com.lanou.bean.T8Tcommodity.*;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * Created by dllo on 18/3/16.
 */
@Repository
public interface T8TCommodityMapper {
    List<Commodity> findCommodity(
                                  @Param("salesDesc") Integer SD,
                                  @Param("priceAsc") Integer PA,
                                  @Param("C1") Integer C1ID,
                                  @Param("C2") Integer C2ID,
                                  @Param("C3") Integer C3ID,
                                  @Param("C4") Integer C4ID,
                                  @Param("priceMax") Double priceMax,
                                  @Param("priceMin") Double priceMin);

    Commodity findCommodityBycommodityID(@Param("commodityID") Integer commodityID);

    List<Brand> findBrandByclassId(@Param("C2") Integer C2ID,
                                   @Param("C3") Integer C3ID);
    List<Brand> findBrand(@Param("C4") Integer C4ID);

    List<Commodity>findOneSales(@Param("C2ID")Integer C2ID);

    List<Commodity>findTwoSales(@Param("C2ID")Integer C2ID);

    List<Commodity>findThreeSales(@Param("C2ID")Integer C2ID);

    List<Commodity>findFourSales(@Param("C2ID")Integer C2ID);

    List<Commodity>findFiveSales(@Param("C2ID")Integer C2ID);

    List<Commodity>findSixSales(@Param("C2ID")Integer C2ID);

    List<Commodity>findSevenSales(@Param("C2ID")Integer C2ID);



    List<Img> findImg(Integer commodityId);

    List<DetailedImg> findDetailedImg(Integer detailedId);

    List<Color> findColor(Integer commodityId);

    List<Size> findSize(Integer commodityId);

    List<ColorSizePrice> findPrice(Integer commodityId);





}
